package no.ntnu.fp.net.db;

import java.sql.SQLException;

public interface CalendarDatabase {
	public String confirmLoginData(String username, String password);
	public String getAllUsers();
	public String CreateNewUser(String username, String name, String password) throws SQLException;

	public String getAppointments(String owner);
	public String getParticipants(String appointmentID);
	public String addAppointment(String owner, String description, String room, String day, 
			String month, String year, String fromTime, String toTime, String[] participants) throws SQLException;
	public String cancelAppointment(String owner, String password, String id) throws SQLException;
	public String removeUserFromAppointment( String owner, String password, String appointmentID, String username ) throws SQLException;
	
	public String getFreeMeetingRooms( String day, String month, String year, String fromTime, String toTime ) throws SQLException;
	public String getAllMeetingRooms() throws SQLException;
	
	public String setNotificationStatus(String id, String status, String username) throws SQLException;
	public String getNotifications( String username );
	public String getAppointmentReplies( String appointmentID );
	
}
